UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2lc7hmDcz4pTv/NJgE7dWq20qnrmfFoSb09ZF6yL/Ek='
WHERE
key_id = '70bc77a2f55e255cfdf3c6076bc5ad7c51a080c565c536e411a3b7437d84a588'
AND (
token = '2lc7hmDcz4pTv/NJgE7dWq20qnrmfFoSb09ZF6yL/Ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)