UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DMMpYLpLbnKIgYJRNIS4DmhiTLysxfIEpVkHnuV4PEo='
WHERE
key_id = '589bd6c932d3ce7f6416f30d7e877e07e46455df0860e345666fdb4146e1ec03'
AND (
token = 'DMMpYLpLbnKIgYJRNIS4DmhiTLysxfIEpVkHnuV4PEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)