UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NbfIHZPR/a1RChxq/UkJS3ICp50bMmQ6plC53g8A2Ps='
WHERE
key_id = 'e45b7ab3be8449b374896dd2e0afcd9c1cdc41877da4020b1febe85c50d4a30b'
AND (
token = 'NbfIHZPR/a1RChxq/UkJS3ICp50bMmQ6plC53g8A2Ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)