UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'guhILmaI9pz5bNwBFZsg/LxAyWmT0gK/1dPuETPs9EY='
WHERE
key_id = 'e83fb1ccf57e81ac24dcc75bfb8a942414e1b11274c7d94be9a5ee704c39870d'
AND (
token = 'guhILmaI9pz5bNwBFZsg/LxAyWmT0gK/1dPuETPs9EY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)