UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tg4csdqAIFBx1tZQZbkZgHggVx3hk4v2FluNkkKnwjo='
WHERE
key_id = '65427e5f09e0812fcb5c110c84490f434012f371beabe2296a97046473cdbfa3'
AND (
token = 'tg4csdqAIFBx1tZQZbkZgHggVx3hk4v2FluNkkKnwjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)