UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P4Q23Tr/2DQVhdZg0BotzwZWMloJY6OU7iSOYaJglbA='
WHERE
key_id = '9147edba13ceb8223939624081447b76d2da3f7bf1b59bdace44709735dd09bc'
AND (
token = 'P4Q23Tr/2DQVhdZg0BotzwZWMloJY6OU7iSOYaJglbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)