UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f37GtyW7U8ZbNzDIUO3xmSvFNNhIh1fT5tIlvboORD8='
WHERE
key_id = '74b2d117791d89e267fe057a00ba8a9f360b273a279e9ccf72664d988b68a3e0'
AND (
token = 'f37GtyW7U8ZbNzDIUO3xmSvFNNhIh1fT5tIlvboORD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)