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