UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPkB0heDMqMoMOx0GCWA2w8ouJlblDUWdRghUTonjT8='
WHERE
key_id = '2f9a4fb6df9828bcba117d4608be5abe31fdb8a3c50adb81c13f4a98371cfc04'
AND (
token = 'sPkB0heDMqMoMOx0GCWA2w8ouJlblDUWdRghUTonjT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)