UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W/CqbtvmtjmHEasZUOrz7BkkXBwuYt2C8buAlE+1zT4='
WHERE
key_id = '1dd7409c3552f0b502a393b3dccf7a5ed21e839f123634b7182bfa6cd70343f5'
AND (
token = 'W/CqbtvmtjmHEasZUOrz7BkkXBwuYt2C8buAlE+1zT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)