UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T/zeG4yIICmTsTTv0DinrKIVRPd9iQSGq2FlGx1gTJ4='
WHERE
key_id = 'd1d123900d7f69e921432bf9f769b272df1e03e5533bae68f764fb8be5679c01'
AND (
token = 'T/zeG4yIICmTsTTv0DinrKIVRPd9iQSGq2FlGx1gTJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)