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