UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8O11WbABAs1AiiRvRYKqjVL8GacpWvFGXXwv4eIUPlA='
WHERE
key_id = 'e8d59f2aeafe891aae3612c3e494b7fb622562be9e16c3d04d5c70a3187aa279'
AND (
token = '8O11WbABAs1AiiRvRYKqjVL8GacpWvFGXXwv4eIUPlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)