UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0h1v4hI8EMGWcpANOji8/Q6Tu8eYcgOof3jyucDh7lE='
WHERE
key_id = 'd4bf81872bfa9183aafd22f29743765079c8a8f7e2f2c38855b30b126f2c222f'
AND (
token = '0h1v4hI8EMGWcpANOji8/Q6Tu8eYcgOof3jyucDh7lE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)