UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'riUFY9m+UK7IbvECUhqx/wQoIdIPvc9sy95ibvVcWCo='
WHERE
key_id = '3eafc3ab50e1f89b07efb699e3946d34dd961a72b053a1d68380ccd9d12b394b'
AND (
token = 'riUFY9m+UK7IbvECUhqx/wQoIdIPvc9sy95ibvVcWCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)