UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4foopP3fmTQcL2y1OB7mnnMhYViT8RwmoJAuvDp4pDg='
WHERE
key_id = 'f5a0b7f9588c0828d7fc7f1d3bf77c74517af914b6cb25cab6ed844333739be6'
AND (
token = '4foopP3fmTQcL2y1OB7mnnMhYViT8RwmoJAuvDp4pDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)