UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v1JCm4La3QTr8Eq3AmjIMM0sN5XM/EbNHc2TVEjeUYI='
WHERE
key_id = '767465388b9432699e513c8dcb268795f7a08e5d6283a13e3bc7d305445d58ce'
AND (
token = 'v1JCm4La3QTr8Eq3AmjIMM0sN5XM/EbNHc2TVEjeUYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)