UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcstSEBhqnA+bocm/tuK/of4Ss9XezCfhxxNxw5KWEY='
WHERE
key_id = '2ba94550837e0756e8984500000fb873b3393c7ce69af4d1bee0099613b937ab'
AND (
token = 'zcstSEBhqnA+bocm/tuK/of4Ss9XezCfhxxNxw5KWEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)