UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7i613DF5GhKV8ofm2J90MKM7BmbB8pYiXzhlTnrcMTA='
WHERE
key_id = 'b78a2a8938975cb1159959983c39033c55dc7082e2c52464ec680644107ea1d3'
AND (
token = '7i613DF5GhKV8ofm2J90MKM7BmbB8pYiXzhlTnrcMTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)