UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sG7JEQukZjzUQkF79o1L+67YdCwriUOP7Mp+nV6OWvs='
WHERE
key_id = 'eeabd74011358b46b28a71762ffd36b26eab95dd0ab1c4d8485958875238af75'
AND (
token = 'sG7JEQukZjzUQkF79o1L+67YdCwriUOP7Mp+nV6OWvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)