UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OpN3++5KX2AAk2VTS7kwo1YFMfVB5rHHuWqUi75PvWQ='
WHERE
key_id = 'dddc9f24f156645a2f3555524167b0fea736dd2788ad293dc7daf7b8337efdc9'
AND (
token = 'OpN3++5KX2AAk2VTS7kwo1YFMfVB5rHHuWqUi75PvWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)