UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7aJudgsjJcxJNh6Y45aqkLFTr+3AKxfuKlOcl4YulU='
WHERE
key_id = '3e71d85ef947d25a2c2780519216b5120ea0241b01058e9e74b5dfd870243abc'
AND (
token = 'D7aJudgsjJcxJNh6Y45aqkLFTr+3AKxfuKlOcl4YulU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)