UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4VnaHxhafX9W72QYJKKfg9iC6n6tizH3OQgo7rGq88='
WHERE
key_id = '02bb76b8d9ce016eb2ab9224ea412d250b2e4254c9940db165c908d3d9c007a3'
AND (
token = 'z4VnaHxhafX9W72QYJKKfg9iC6n6tizH3OQgo7rGq88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)