UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nVZZd40c/1T411vpA2sQDoNRtgXD3QIdZpTu55XAQes='
WHERE
key_id = 'b70c308e5d99163c5e5800a9fd80d160d5d6db42fc8874400d6debd66bbe5a28'
AND (
token = 'nVZZd40c/1T411vpA2sQDoNRtgXD3QIdZpTu55XAQes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)