UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HE8gW8H10kexkaxHtgmJks2xTPYQ7ACoGD3npEHnoPI='
WHERE
key_id = 'a31347a89bc909b0ef27e42f156c21bf358ef57f74b7ea7eff6de1617c38edd5'
AND (
token = 'HE8gW8H10kexkaxHtgmJks2xTPYQ7ACoGD3npEHnoPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)