UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBRVVhHqWr08Ah2RvvLysa+i0WlWyiU8I2rZxKg2hcY='
WHERE
key_id = '8ef9a40f8107114344b3062b3d825dd211cff7c121cdda7b0b96df64283a70a6'
AND (
token = 'zBRVVhHqWr08Ah2RvvLysa+i0WlWyiU8I2rZxKg2hcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)