UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uA9ZXfDgwfwcZEcDbkg4IvcC8Fq3DvzmzzFzij9tTBo='
WHERE
key_id = 'c5642557962f60a43ba1d918930f72f98b611431fdabfb9047e021f4969049a2'
AND (
token = 'uA9ZXfDgwfwcZEcDbkg4IvcC8Fq3DvzmzzFzij9tTBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)