UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dL0zVNtZJkJN5DWsjpPpmNUyzLZkSEaxhou79H/LbEw='
WHERE
key_id = '00998409acee3a54d18909b1f5678c9676fb11d2dd793b281c29a8f53ae99fe8'
AND (
token = 'dL0zVNtZJkJN5DWsjpPpmNUyzLZkSEaxhou79H/LbEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)