UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7N5OUOy/XGxNBvaqLlOouXd4QOIZzWBuJ+yJ5XiquWI='
WHERE
key_id = 'ad938bd62559bf704ec59713233c51dd02c0a2e1086be9a7a224451891d9232f'
AND (
token = '7N5OUOy/XGxNBvaqLlOouXd4QOIZzWBuJ+yJ5XiquWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)